package com.ruoyi.report_sj.mapper;

import com.ruoyi.base.domain.vo.SyYjVo;
import com.ruoyi.report_sj.domain.ReportSjKyqdBsInfo;
import com.ruoyi.report_sj.domain.vo.ReportSjKyqdBsInfoVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 砂浆抗压强度试验检测记录Mapper接口
 *
 * @author zyb
 * @date 2024-05-29
 */
public interface ReportSjKyqdBsInfoMapper extends BaseMapperPlus<ReportSjKyqdBsInfoMapper, ReportSjKyqdBsInfo, ReportSjKyqdBsInfoVo> {

    @Select("SELECT a.* FROM base_sy_yj a where a.parent_id = (select sy_yj_id from base_sy_yj b where b.sy_yj_name like '%${qddj}%')")
    List<SyYjVo> getQddj(@Param("qddj") String qddj);
}
